IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[UpdateCuenta]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[UpdateCuenta]
GO

CREATE PROCEDURE [dbo].[UpdateCuenta]
(
	@IdCuenta int,
	@IdBanco int,
	@Numero varchar(50),
	@Tipo tinyint
)
AS
BEGIN
	SET NOCOUNT ON

	UPDATE [Cuenta]
	SET [IdBanco] = @IdBanco, 
		[Numero] = @Numero, 
		[Tipo] = @Tipo
	WHERE [IdCuenta] = @IdCuenta

	SET NOCOUNT OFF
END

GO
